Parameter <name> has no default value. (Error 3748)

This occurs when using procedures. It occurs when a default value is trying to be utilized and the parameter does not have a defined default value. To prevent this error message, define a default value on the procedure, or pass in a value to the parameter.